//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Copyright 2007 CORE Solutions Limited
// All rights reserved.
// PROPRIETARY AND CONFIDENTIAL INFORMATION.
// Use is subject to license terms.
//
// FUNCTION ID      :   FACT_AUDIT
// AUTHOR           :   Ray Guo 
// DATE CREATE      :   2007/09/10
// DESCRIPTION      :   a SCHEMA file for the function, FACT_AUDIT
//                  :   
//                  :   
//                  :   
//
// MODIFICATION HISTORY:
// DATE         AUTHOR          VERSION NO.         COMMENT
// -----------  --------------  ------------------  -------------------
// 2007/09/10   Ray Guo         1.0                 source is generated.
//
//
//
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

package com.erp.app.compliance.factAudit.schema;

import com.erp.framework.model.schema.MetaData;
import com.erp.framework.model.schema.TableSchema;

/**
* <p>A <strong>Schema</strong> stores the table meta information.
* The main purpose for this class is to validate the lengths of UniCode Characters,
* and notify the database to store UniCode characters from web browsers.
*
* @author          Ray Guo 
* @version 1.0     2007/09/10
* @since           FrameWork 1.0
*
*/
public class FactAuditAttachSchema extends TableSchema {

	public static final String TABLE_NAME = "T_FACT_AUDIT_ATTACH";

	public FactAuditAttachSchema(){

		MetaData md = null;

		md = new MetaData();
		md.setColumnName("COMPANY_CODE");
		md.setVoPropertyName("companyCode");
		md.setColumnTitle("COMPANY_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_ATTACH_COMPANY_CODE");
		md.setWebLabelName("DEF ATTACH COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_COMPANY_CODE");
		md.setVoPropertyName("srchCompanyCodeFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_COMPANY_CODE");
		md.setWebLabelName("DEF SRCH COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_COMPANY_CODE");
		md.setVoPropertyName("srchCompanyCodeTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_COMPANY_CODE");
		md.setWebLabelName("DEF SRCH COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_COMPANY_CODE");
		md.setVoPropertyName("lblGridCompanyCode");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_COMPANY_CODE");
		md.setWebLabelName("DEF GRID COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("AUDIT_NO");
		md.setVoPropertyName("auditNo");
		md.setColumnTitle("AUDIT_NO");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_ATTACH_AUDIT_NO");
		md.setWebLabelName("DEF ATTACH AUDIT NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_AUDIT_NO");
		md.setVoPropertyName("srchAuditNoFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_AUDIT_NO");
		md.setWebLabelName("DEF SRCH AUDIT NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_AUDIT_NO");
		md.setVoPropertyName("srchAuditNoTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_AUDIT_NO");
		md.setWebLabelName("DEF SRCH AUDIT NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_AUDIT_NO");
		md.setVoPropertyName("lblGridAuditNo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_AUDIT_NO");
		md.setWebLabelName("DEF GRID AUDIT NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LINE_NO");
		md.setVoPropertyName("attachLineNo");
		md.setColumnTitle("LINE_NO");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(17);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_ATTACH_LINE_NO");
		md.setWebLabelName("DEF ATTACH LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_LINE_NO");
		md.setVoPropertyName("srchAttachLineNoFr");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_LINE_NO");
		md.setWebLabelName("DEF SRCH LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_LINE_NO");
		md.setVoPropertyName("srchAttachLineNoTo");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_LINE_NO");
		md.setWebLabelName("DEF SRCH LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_LINE_NO");
		md.setVoPropertyName("lblGridAttachLineNo");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_LINE_NO");
		md.setWebLabelName("DEF GRID LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("ATTACH_DESC");
		md.setVoPropertyName("attachAttachDesc");
		md.setColumnTitle("ATTACH_DESC");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_ATTACH_ATTACH_DESC");
		md.setWebLabelName("DEF ATTACH ATTACH DESC");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_ATTACH_DESC");
		md.setVoPropertyName("srchAttachAttachDescFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_ATTACH_DESC");
		md.setWebLabelName("DEF SRCH ATTACH DESC");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_ATTACH_DESC");
		md.setVoPropertyName("srchAttachAttachDescTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_ATTACH_DESC");
		md.setWebLabelName("DEF SRCH ATTACH DESC");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_ATTACH_DESC");
		md.setVoPropertyName("lblGridAttachAttachDesc");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_ATTACH_DESC");
		md.setWebLabelName("DEF GRID ATTACH DESC");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("ATTACH_LINE_NO");
		md.setVoPropertyName("attachAttachLineNo");
		md.setColumnTitle("ATTACH_LINE_NO");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigDecimal");
		md.setColumnPrecision(17);
		md.setColumnScale(6);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_ATTACH_ATTACH_LINE_NO");
		md.setWebLabelName("DEF ATTACH ATTACH LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_ATTACH_LINE_NO");
		md.setVoPropertyName("srchAttachAttachLineNoFr");
		md.setColumnClassName("com.erp.framework.types.CustomBigDecimal");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_ATTACH_LINE_NO");
		md.setWebLabelName("DEF SRCH ATTACH LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_ATTACH_LINE_NO");
		md.setVoPropertyName("srchAttachAttachLineNoTo");
		md.setColumnClassName("com.erp.framework.types.CustomBigDecimal");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_ATTACH_LINE_NO");
		md.setWebLabelName("DEF SRCH ATTACH LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_ATTACH_LINE_NO");
		md.setVoPropertyName("lblGridAttachAttachLineNo");
		md.setColumnClassName("com.erp.framework.types.CustomBigDecimal");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_ATTACH_LINE_NO");
		md.setWebLabelName("DEF GRID ATTACH LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_ATTACH_SELECT");
		md.setWebLabelName("DEF ATTACH SELECT");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_ATTACH_DELETE");
		md.setWebLabelName("DEF ATTACH DELETE");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);
		
		md = new MetaData();
		md.setWebObjectId("LBL_ATTACH_ATTACH");
		md.setWebLabelName("DEF ATTACH ATTACH");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);
	}

}